home *** CD-ROM | disk | FTP | other *** search
/ Power Programmierung / Power-Programmierung (Tewi)(1994).iso / magazine / dbms_mag / 9103 / sql3.mar < prev    next >
Text File  |  1991-01-22  |  185b  |  2 lines
  1.  
  2. CREATE VIEW canadian_values (c#, name, i#, order_value) AS  SELECT c#, name, i#, order_value * currency.rate    FROM complete_order, currency   WHERE currency.country = 'Canada';